Unable to retrieve current week."; } else { $res_count = mysql_num_rows($result); if($res_count > 0) { foreach($res as $key => $val) { $currWeek = $val['weekno']; $currYear = $val['yearno']; $displayWeek = $currWeek - 1; } } } if(isset($_GET['wk'])) { $weekNum = $_GET['wk']; } else { $weekNum = $displayWeek; } $standings_arr = array(array()); //$dbg = "
standings.php:\n";
//$dbg .= "weekNum = ".$weekNum."\n";
//echo $dbg."
"; //exit; if($weekNum == 0) { $weekNum = 1; } if($weekNum > 17) { $weekNum = 17; } $stand_arr = array(array()); $key_arr = array('teamNo','rank','teamName','ytdTotal','ytdAverage','weekTotal','winner'); $tCount = 0; $sql = "select s.teamNo, s.rank, p.teamName, s.ytdTotal, s.ytdAverage, s.weekTotal, winner from standings".$currYear." s left join prteams".$currYear." p on s.teamNo = p.teamNo where s.weekNo = ".$weekNum." order by rank asc"; $result = mysql_query($sql); $numCols = mysql_num_fields($result); $resCount = mysql_num_rows($result); $res = fillArray($result); $dbg .= "numCols = ".$numCols."\n"; $dbg .= "resCount = ".$resCount."\n"; if(!$result) { echo "
Unable to retrieve standings.
"; } else { if($resCount > 0) { foreach($res as $key => $val) { for($i = 0; $i < $numCols; $i++) { $standings_arr[$tCount][$key_arr[$i]] = $val[$i]; } $tCount++; } } } $dbg .= "standings_arr: ".count($standings_arr)."\n"; for($j = 0; $j < count($standings_arr); $j++) { foreach($standings_arr[$j] as $key => $val) { $dbg .= $key." = ".$val." | "; } $dbg .= "\n"; } //echo $dbg.""; pageHead('standings'); ?>
'; echo ''; //echo ''; echo ''; echo ''; echo ''; echo ''; if($standings_arr[$j]['winner']) { echo ''; } else { echo ''; } echo ''; } ?>
RANKTEAMTOTALAVGPOINTSWIN
'.$standings_arr[$j]['rank'].''.$standings_arr[$j]['teamName'].'
'.$standings_arr[$j]['teamName'].'
'.$standings_arr[$j]['ytdTotal'].''.$standings_arr[$j]['ytdAverage'].''.$standings_arr[$j]['weekTotal'].' 
 WEEK Go to week: